﻿<?xml version="1.0" encoding="utf-8" ?>
<snippets>
  <snippet shortcut="ssf">SELECT	*
FROM	$table$
$end$</snippet>
  <snippet shortcut="sf">SELECT	*
FROM	$carret$
$DropMarker$</snippet>
  <snippet shortcut="ssff">SELECT * FROM $carret$</snippet>
  <snippet shortcut="stt">SELECT	TOP 10 *
FROM	$table$(nolock)
$end$
</snippet>
  <snippet shortcut="j">JOIN	$JoinedTable$(nolock)
ON		$end$
</snippet>
  <snippet shortcut="w">WHERE	</snippet>
  <snippet shortcut="o">ON	</snippet>
  <snippet shortcut="l">LEFT($end$)$DropMarker$</snippet>
  <snippet shortcut="r">RIGHT($end$)$DropMarker$</snippet>
  <snippet shortcut="n">IN($end$)$DropMarker$</snippet>
  <snippet shortcut="nb">IN
(
	$end$
)$DropMarker$</snippet>
  <snippet shortcut="lj">LEFT JOIN	</snippet>
  <snippet shortcut="uc">$anchor$USE Core
GO
$carret$</snippet>
  <snippet shortcut="ts">TOP $anchor$10$carret$ *$DropMarker$</snippet>
  <snippet shortcut="nl">(nolock)</snippet>
  <snippet shortcut="cur">DECLARE $@variable$	INT
DECLARE	$CursorName$
CURSOR	FOR
$End$
OPEN	$CursorName$
FETCH	NEXT 
FROM	$CursorName$
INTO	$@variable$

WHILE @@@FETCH_STATUS = 0
BEGIN
$DropMarker$

FETCH	NEXT 
FROM	$CursorName$
INTO	$@variable$
END

CLOSE		$CursorName$
DEALLOCATE	$CursorName$</snippet>
  <snippet shortcut="dvc">DECLARE @$variable$	VARCHAR($50$)$End$</snippet>
  <snippet shortcut="f">for (int $i$=0;$i$&lt;$count$;$i$++)
{
	$end$
}</snippet>
</snippets>
